﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$ContactsDBConnection$" formatter="bizobj of Contact">
	<Sql>
    SELECT
    id
    ,extId
    ,lastName
    ,firstName
    ,middleName
    ,phone
    ,mobile
    ,email
    ,isUser
    ,typeId as type_id
    ,companyId
    ,avitarImage,customTitle,dateOfBirth,gender,location
    FROM Contacts
    WHERE CONTACTS.extId = @extId
  </Sql>
	<Sql type="SqlServer">
		
	</Sql>
	<Param name="extId" type="String" />
</AdoNetDataAccess>